package com.action;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;

import com.bean.*;
import com.dao.*;
public class DomitoryRZ extends ActionSupport {
	//下面是Action内用于封装用户请求参数的属性
		private List<StudentBean> list;
		public List<StudentBean> getList() {
			return list;
		}
		public void setList(List<StudentBean> list) {
			this.list = list;
		}
		private String SearchRow;
		private String SearchKey;
		public String getSearchRow() {
			return SearchRow;
		}
		public void setSearchRow(String searchRow) {
			SearchRow = searchRow;
		}
		public String getSearchKey() {
			return SearchKey;
		}
		public void setSearchKey(String searchKey) {
			SearchKey = searchKey;
		}
		private List<DomitoryBean> domitorylist;
		public List<DomitoryBean> getDomitorylist() {
			return domitorylist;
		}
		public void setDomitorylist(List<DomitoryBean> domitorylist) {
			this.domitorylist = domitorylist;
		}
		private String Student_DomitoryName;
		public String getStudent_DomitoryName() {
			return Student_DomitoryName;
		}
		public void setStudent_DomitoryName(String studentDomitoryName) {
			Student_DomitoryName = studentDomitoryName;
		}
		//处理用户请求的execute方法
		public String execute() throws Exception {
			
			//解决乱码，用于页面输出
			HttpServletResponse response=null;
			response=ServletActionContext.getResponse();
			response.setContentType("text/html;charset=UTF-8");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			
			//创建session对象
			HttpSession session = ServletActionContext.getRequest().getSession();
			//验证是否正常登录
			if(session.getAttribute("id")==null){
				out.print("<script language='javascri pt'>alert('请重新登录！');window.location='Login.jsp';</script>");
				out.flush();out.close();return null;
			}
			//查询条件
			String strWhere="1=1";
			if(!(isInvalid(SearchKey)))
			{
				strWhere+=" and "+SearchRow+"='"+SearchKey+"'";
			}
			
			strWhere=(String) session.getAttribute("name");
			//根据姓名获得性别和院系
			StudentBean st=new StudentDao().doFindByName(strWhere);
			
			strWhere=" Domitory_Sex='"+st.getStudent_Sex()+"' and Domitory_Type='"+st.getStudent_Class()+"'";
			
			//查询宿舍
			domitorylist=new DomitoryDao().GetList(strWhere,"Domitory_Name");
			
			strWhere=" Student_Sex='"+st.getStudent_Sex()+"' and Student_Class='"+st.getStudent_Class()+"'";
			//查询所有
			list=new StudentDao().GetList(strWhere,"Student_Name");
			
			return SUCCESS;
	}
		//判断是否空值
		private boolean isInvalid(String value) {
			return (value == null || value.length() == 0);
		}
		
		//测试
		public static void main(String[] args) {
			System.out.println();
		}
		}

